﻿#region Using directives

using System;
using System.Data;
using System.Collections;
using System.Collections.Generic;
using System.Diagnostics;
using InvoiceChecking.Entities;
using InvoiceChecking.Data;

#endregion

namespace InvoiceChecking.Data.Bases
{	
	///<summary>
	/// This class is the base class for any <see cref="VrProcPharRevProviderBase"/> implementation.
	/// It exposes CRUD methods as well as selecting on index, foreign keys and custom stored procedures.
	///</summary>
	public abstract class VrProcPharRevProviderBaseCore : EntityViewProviderBase<VrProcPharRev>
	{
		#region Custom Methods
		
		
		#endregion

		#region Helper Functions
		
		/*
		///<summary>
		/// Fill an VList&lt;VrProcPharRev&gt; From a DataSet
		///</summary>
		/// <param name="dataSet">the DataSet</param>
		/// <param name="rows">The collection to fill</param>
		/// <param name="start">Start row</param>
		/// <param name="pagelen">number of row.</param>
		///<returns><see chref="VList&lt;VrProcPharRev&gt;"/></returns>
		protected static VList&lt;VrProcPharRev&gt; Fill(DataSet dataSet, VList<VrProcPharRev> rows, int start, int pagelen)
		{
			if (dataSet.Tables.Count == 1)
			{
				return Fill(dataSet.Tables[0], rows, start, pagelen);
			}
			else
			{
				return new VList<VrProcPharRev>();
			}	
		}
		
		
		///<summary>
		/// Fill an VList&lt;VrProcPharRev&gt; From a DataTable
		///</summary>
		/// <param name="dataTable">the DataTable that hold the data.</param>
		/// <param name="rows">The collection to fill</param>
		/// <param name="start">Start row</param>
		/// <param name="pagelen">number of row.</param>
		///<returns><see chref="VList<VrProcPharRev>"/></returns>
		protected static VList&lt;VrProcPharRev&gt; Fill(DataTable dataTable, VList<VrProcPharRev> rows, int start, int pagelen)
		{
			int recordnum = 0;
			
			System.Collections.IEnumerator dataRows =  dataTable.Rows.GetEnumerator();
			
			while (dataRows.MoveNext() && (pagelen != 0))
			{
				if(recordnum >= start)
				{
					DataRow row = (DataRow)dataRows.Current;
				
					VrProcPharRev c = new VrProcPharRev();
					c.DateVisit = (Convert.IsDBNull(row["DATE_VISIT"]))?DateTime.MinValue:(System.DateTime)row["DATE_VISIT"];
					c.VatNumber = (Convert.IsDBNull(row["VAT_NUmber"]))?string.Empty:(System.String)row["VAT_NUmber"];
					c.InvNber = (Convert.IsDBNull(row["INV_NBER"]))?string.Empty:(System.String)row["INV_NBER"];
					c.PatFilcod = (Convert.IsDBNull(row["PAT_FILCOD"]))?string.Empty:(System.String)row["PAT_FILCOD"];
					c.CashCredit = (Convert.IsDBNull(row["Cash_Credit"]))?string.Empty:(System.String)row["Cash_Credit"];
					c.ProcPharX = (Convert.IsDBNull(row["PROC_PHAR_X"]))?(short)0:(System.Int16?)row["PROC_PHAR_X"];
					c.ProcPharCode = (Convert.IsDBNull(row["PROC_PHAR_CODE"]))?string.Empty:(System.String)row["PROC_PHAR_CODE"];
					c.ProcPharName = (Convert.IsDBNull(row["PROC_PHAR_NAME"]))?string.Empty:(System.String)row["PROC_PHAR_NAME"];
					c.ProcPharPay = (Convert.IsDBNull(row["PROC_PHAR_PAY"]))?0.0f:(System.Double?)row["PROC_PHAR_PAY"];
					c.PatNatio = (Convert.IsDBNull(row["PAT_NATIO"]))?string.Empty:(System.String)row["PAT_NATIO"];
					c.UpdDocCode = (Convert.IsDBNull(row["UPD_DOC_CODE"]))?string.Empty:(System.String)row["UPD_DOC_CODE"];
					c.UpdDocAlias = (Convert.IsDBNull(row["UPD_DOC_ALIAS"]))?string.Empty:(System.String)row["UPD_DOC_ALIAS"];
					c.JobCorp = (Convert.IsDBNull(row["JOB_CORP"]))?string.Empty:(System.String)row["JOB_CORP"];
					c.PatientName = (Convert.IsDBNull(row["Patient_Name"]))?string.Empty:(System.String)row["Patient_Name"];
					c.AeaProgr = (Convert.IsDBNull(row["AEA_PROGR"]))?string.Empty:(System.String)row["AEA_PROGR"];
					c.PatDob = (Convert.IsDBNull(row["PAT_DOB"]))?DateTime.MinValue:(System.DateTime?)row["PAT_DOB"];
					c.DrugName = (Convert.IsDBNull(row["DRUG_NAME"]))?string.Empty:(System.String)row["DRUG_NAME"];
					c.DispName = (Convert.IsDBNull(row["DISP_NAME"]))?string.Empty:(System.String)row["DISP_NAME"];
					c.CmsCenter = (Convert.IsDBNull(row["CMS_Center"]))?string.Empty:(System.String)row["CMS_Center"];
					c.PatSex = (Convert.IsDBNull(row["PAT_SEX"]))?string.Empty:(System.String)row["PAT_SEX"];
					c.AcceptChanges();
					rows.Add(c);
					pagelen -= 1;
				}
				recordnum += 1;
			}
			return rows;
		}
		*/	
						
		///<summary>
		/// Fill an <see cref="VList&lt;VrProcPharRev&gt;"/> From a DataReader.
		///</summary>
		/// <param name="reader">Datareader</param>
		/// <param name="rows">The collection to fill</param>
		/// <param name="start">Start row</param>
		/// <param name="pageLength">number of row.</param>
		///<returns>a <see cref="VList&lt;VrProcPharRev&gt;"/></returns>
		protected VList<VrProcPharRev> Fill(IDataReader reader, VList<VrProcPharRev> rows, int start, int pageLength)
		{
			int recordnum = 0;
			while (reader.Read() && (pageLength != 0))
			{
				if(recordnum >= start)
				{
					VrProcPharRev entity = null;
					if (DataRepository.Provider.UseEntityFactory)
					{
						entity = EntityManager.CreateViewEntity<VrProcPharRev>("VrProcPharRev",  DataRepository.Provider.EntityCreationalFactoryType); 
					}
					else
					{
						entity = new VrProcPharRev();
					}
					
					entity.SuppressEntityEvents = true;

					entity.DateVisit = (System.DateTime)reader[((int)VrProcPharRevColumn.DateVisit)];
					//entity.DateVisit = (Convert.IsDBNull(reader["DATE_VISIT"]))?DateTime.MinValue:(System.DateTime)reader["DATE_VISIT"];
					entity.VatNumber = (reader.IsDBNull(((int)VrProcPharRevColumn.VatNumber)))?null:(System.String)reader[((int)VrProcPharRevColumn.VatNumber)];
					//entity.VatNumber = (Convert.IsDBNull(reader["VAT_NUmber"]))?string.Empty:(System.String)reader["VAT_NUmber"];
					entity.InvNber = (System.String)reader[((int)VrProcPharRevColumn.InvNber)];
					//entity.InvNber = (Convert.IsDBNull(reader["INV_NBER"]))?string.Empty:(System.String)reader["INV_NBER"];
					entity.PatFilcod = (reader.IsDBNull(((int)VrProcPharRevColumn.PatFilcod)))?null:(System.String)reader[((int)VrProcPharRevColumn.PatFilcod)];
					//entity.PatFilcod = (Convert.IsDBNull(reader["PAT_FILCOD"]))?string.Empty:(System.String)reader["PAT_FILCOD"];
					entity.CashCredit = (System.String)reader[((int)VrProcPharRevColumn.CashCredit)];
					//entity.CashCredit = (Convert.IsDBNull(reader["Cash_Credit"]))?string.Empty:(System.String)reader["Cash_Credit"];
					entity.ProcPharX = (reader.IsDBNull(((int)VrProcPharRevColumn.ProcPharX)))?null:(System.Int16?)reader[((int)VrProcPharRevColumn.ProcPharX)];
					//entity.ProcPharX = (Convert.IsDBNull(reader["PROC_PHAR_X"]))?(short)0:(System.Int16?)reader["PROC_PHAR_X"];
					entity.ProcPharCode = (reader.IsDBNull(((int)VrProcPharRevColumn.ProcPharCode)))?null:(System.String)reader[((int)VrProcPharRevColumn.ProcPharCode)];
					//entity.ProcPharCode = (Convert.IsDBNull(reader["PROC_PHAR_CODE"]))?string.Empty:(System.String)reader["PROC_PHAR_CODE"];
					entity.ProcPharName = (reader.IsDBNull(((int)VrProcPharRevColumn.ProcPharName)))?null:(System.String)reader[((int)VrProcPharRevColumn.ProcPharName)];
					//entity.ProcPharName = (Convert.IsDBNull(reader["PROC_PHAR_NAME"]))?string.Empty:(System.String)reader["PROC_PHAR_NAME"];
					entity.ProcPharPay = (reader.IsDBNull(((int)VrProcPharRevColumn.ProcPharPay)))?null:(System.Double?)reader[((int)VrProcPharRevColumn.ProcPharPay)];
					//entity.ProcPharPay = (Convert.IsDBNull(reader["PROC_PHAR_PAY"]))?0.0f:(System.Double?)reader["PROC_PHAR_PAY"];
					entity.PatNatio = (reader.IsDBNull(((int)VrProcPharRevColumn.PatNatio)))?null:(System.String)reader[((int)VrProcPharRevColumn.PatNatio)];
					//entity.PatNatio = (Convert.IsDBNull(reader["PAT_NATIO"]))?string.Empty:(System.String)reader["PAT_NATIO"];
					entity.UpdDocCode = (reader.IsDBNull(((int)VrProcPharRevColumn.UpdDocCode)))?null:(System.String)reader[((int)VrProcPharRevColumn.UpdDocCode)];
					//entity.UpdDocCode = (Convert.IsDBNull(reader["UPD_DOC_CODE"]))?string.Empty:(System.String)reader["UPD_DOC_CODE"];
					entity.UpdDocAlias = (reader.IsDBNull(((int)VrProcPharRevColumn.UpdDocAlias)))?null:(System.String)reader[((int)VrProcPharRevColumn.UpdDocAlias)];
					//entity.UpdDocAlias = (Convert.IsDBNull(reader["UPD_DOC_ALIAS"]))?string.Empty:(System.String)reader["UPD_DOC_ALIAS"];
					entity.JobCorp = (reader.IsDBNull(((int)VrProcPharRevColumn.JobCorp)))?null:(System.String)reader[((int)VrProcPharRevColumn.JobCorp)];
					//entity.JobCorp = (Convert.IsDBNull(reader["JOB_CORP"]))?string.Empty:(System.String)reader["JOB_CORP"];
					entity.PatientName = (reader.IsDBNull(((int)VrProcPharRevColumn.PatientName)))?null:(System.String)reader[((int)VrProcPharRevColumn.PatientName)];
					//entity.PatientName = (Convert.IsDBNull(reader["Patient_Name"]))?string.Empty:(System.String)reader["Patient_Name"];
					entity.AeaProgr = (reader.IsDBNull(((int)VrProcPharRevColumn.AeaProgr)))?null:(System.String)reader[((int)VrProcPharRevColumn.AeaProgr)];
					//entity.AeaProgr = (Convert.IsDBNull(reader["AEA_PROGR"]))?string.Empty:(System.String)reader["AEA_PROGR"];
					entity.PatDob = (reader.IsDBNull(((int)VrProcPharRevColumn.PatDob)))?null:(System.DateTime?)reader[((int)VrProcPharRevColumn.PatDob)];
					//entity.PatDob = (Convert.IsDBNull(reader["PAT_DOB"]))?DateTime.MinValue:(System.DateTime?)reader["PAT_DOB"];
					entity.DrugName = (reader.IsDBNull(((int)VrProcPharRevColumn.DrugName)))?null:(System.String)reader[((int)VrProcPharRevColumn.DrugName)];
					//entity.DrugName = (Convert.IsDBNull(reader["DRUG_NAME"]))?string.Empty:(System.String)reader["DRUG_NAME"];
					entity.DispName = (reader.IsDBNull(((int)VrProcPharRevColumn.DispName)))?null:(System.String)reader[((int)VrProcPharRevColumn.DispName)];
					//entity.DispName = (Convert.IsDBNull(reader["DISP_NAME"]))?string.Empty:(System.String)reader["DISP_NAME"];
					entity.CmsCenter = (System.String)reader[((int)VrProcPharRevColumn.CmsCenter)];
					//entity.CmsCenter = (Convert.IsDBNull(reader["CMS_Center"]))?string.Empty:(System.String)reader["CMS_Center"];
					entity.PatSex = (reader.IsDBNull(((int)VrProcPharRevColumn.PatSex)))?null:(System.String)reader[((int)VrProcPharRevColumn.PatSex)];
					//entity.PatSex = (Convert.IsDBNull(reader["PAT_SEX"]))?string.Empty:(System.String)reader["PAT_SEX"];
					entity.AcceptChanges();
					entity.SuppressEntityEvents = false;
					
					rows.Add(entity);
					pageLength -= 1;
				}
				recordnum += 1;
			}
			return rows;
		}
		
		
		/// <summary>
		/// Refreshes the <see cref="VrProcPharRev"/> object from the <see cref="IDataReader"/>.
		/// </summary>
		/// <param name="reader">The <see cref="IDataReader"/> to read from.</param>
		/// <param name="entity">The <see cref="VrProcPharRev"/> object to refresh.</param>
		protected void RefreshEntity(IDataReader reader, VrProcPharRev entity)
		{
			reader.Read();
			entity.DateVisit = (System.DateTime)reader[((int)VrProcPharRevColumn.DateVisit)];
			//entity.DateVisit = (Convert.IsDBNull(reader["DATE_VISIT"]))?DateTime.MinValue:(System.DateTime)reader["DATE_VISIT"];
			entity.VatNumber = (reader.IsDBNull(((int)VrProcPharRevColumn.VatNumber)))?null:(System.String)reader[((int)VrProcPharRevColumn.VatNumber)];
			//entity.VatNumber = (Convert.IsDBNull(reader["VAT_NUmber"]))?string.Empty:(System.String)reader["VAT_NUmber"];
			entity.InvNber = (System.String)reader[((int)VrProcPharRevColumn.InvNber)];
			//entity.InvNber = (Convert.IsDBNull(reader["INV_NBER"]))?string.Empty:(System.String)reader["INV_NBER"];
			entity.PatFilcod = (reader.IsDBNull(((int)VrProcPharRevColumn.PatFilcod)))?null:(System.String)reader[((int)VrProcPharRevColumn.PatFilcod)];
			//entity.PatFilcod = (Convert.IsDBNull(reader["PAT_FILCOD"]))?string.Empty:(System.String)reader["PAT_FILCOD"];
			entity.CashCredit = (System.String)reader[((int)VrProcPharRevColumn.CashCredit)];
			//entity.CashCredit = (Convert.IsDBNull(reader["Cash_Credit"]))?string.Empty:(System.String)reader["Cash_Credit"];
			entity.ProcPharX = (reader.IsDBNull(((int)VrProcPharRevColumn.ProcPharX)))?null:(System.Int16?)reader[((int)VrProcPharRevColumn.ProcPharX)];
			//entity.ProcPharX = (Convert.IsDBNull(reader["PROC_PHAR_X"]))?(short)0:(System.Int16?)reader["PROC_PHAR_X"];
			entity.ProcPharCode = (reader.IsDBNull(((int)VrProcPharRevColumn.ProcPharCode)))?null:(System.String)reader[((int)VrProcPharRevColumn.ProcPharCode)];
			//entity.ProcPharCode = (Convert.IsDBNull(reader["PROC_PHAR_CODE"]))?string.Empty:(System.String)reader["PROC_PHAR_CODE"];
			entity.ProcPharName = (reader.IsDBNull(((int)VrProcPharRevColumn.ProcPharName)))?null:(System.String)reader[((int)VrProcPharRevColumn.ProcPharName)];
			//entity.ProcPharName = (Convert.IsDBNull(reader["PROC_PHAR_NAME"]))?string.Empty:(System.String)reader["PROC_PHAR_NAME"];
			entity.ProcPharPay = (reader.IsDBNull(((int)VrProcPharRevColumn.ProcPharPay)))?null:(System.Double?)reader[((int)VrProcPharRevColumn.ProcPharPay)];
			//entity.ProcPharPay = (Convert.IsDBNull(reader["PROC_PHAR_PAY"]))?0.0f:(System.Double?)reader["PROC_PHAR_PAY"];
			entity.PatNatio = (reader.IsDBNull(((int)VrProcPharRevColumn.PatNatio)))?null:(System.String)reader[((int)VrProcPharRevColumn.PatNatio)];
			//entity.PatNatio = (Convert.IsDBNull(reader["PAT_NATIO"]))?string.Empty:(System.String)reader["PAT_NATIO"];
			entity.UpdDocCode = (reader.IsDBNull(((int)VrProcPharRevColumn.UpdDocCode)))?null:(System.String)reader[((int)VrProcPharRevColumn.UpdDocCode)];
			//entity.UpdDocCode = (Convert.IsDBNull(reader["UPD_DOC_CODE"]))?string.Empty:(System.String)reader["UPD_DOC_CODE"];
			entity.UpdDocAlias = (reader.IsDBNull(((int)VrProcPharRevColumn.UpdDocAlias)))?null:(System.String)reader[((int)VrProcPharRevColumn.UpdDocAlias)];
			//entity.UpdDocAlias = (Convert.IsDBNull(reader["UPD_DOC_ALIAS"]))?string.Empty:(System.String)reader["UPD_DOC_ALIAS"];
			entity.JobCorp = (reader.IsDBNull(((int)VrProcPharRevColumn.JobCorp)))?null:(System.String)reader[((int)VrProcPharRevColumn.JobCorp)];
			//entity.JobCorp = (Convert.IsDBNull(reader["JOB_CORP"]))?string.Empty:(System.String)reader["JOB_CORP"];
			entity.PatientName = (reader.IsDBNull(((int)VrProcPharRevColumn.PatientName)))?null:(System.String)reader[((int)VrProcPharRevColumn.PatientName)];
			//entity.PatientName = (Convert.IsDBNull(reader["Patient_Name"]))?string.Empty:(System.String)reader["Patient_Name"];
			entity.AeaProgr = (reader.IsDBNull(((int)VrProcPharRevColumn.AeaProgr)))?null:(System.String)reader[((int)VrProcPharRevColumn.AeaProgr)];
			//entity.AeaProgr = (Convert.IsDBNull(reader["AEA_PROGR"]))?string.Empty:(System.String)reader["AEA_PROGR"];
			entity.PatDob = (reader.IsDBNull(((int)VrProcPharRevColumn.PatDob)))?null:(System.DateTime?)reader[((int)VrProcPharRevColumn.PatDob)];
			//entity.PatDob = (Convert.IsDBNull(reader["PAT_DOB"]))?DateTime.MinValue:(System.DateTime?)reader["PAT_DOB"];
			entity.DrugName = (reader.IsDBNull(((int)VrProcPharRevColumn.DrugName)))?null:(System.String)reader[((int)VrProcPharRevColumn.DrugName)];
			//entity.DrugName = (Convert.IsDBNull(reader["DRUG_NAME"]))?string.Empty:(System.String)reader["DRUG_NAME"];
			entity.DispName = (reader.IsDBNull(((int)VrProcPharRevColumn.DispName)))?null:(System.String)reader[((int)VrProcPharRevColumn.DispName)];
			//entity.DispName = (Convert.IsDBNull(reader["DISP_NAME"]))?string.Empty:(System.String)reader["DISP_NAME"];
			entity.CmsCenter = (System.String)reader[((int)VrProcPharRevColumn.CmsCenter)];
			//entity.CmsCenter = (Convert.IsDBNull(reader["CMS_Center"]))?string.Empty:(System.String)reader["CMS_Center"];
			entity.PatSex = (reader.IsDBNull(((int)VrProcPharRevColumn.PatSex)))?null:(System.String)reader[((int)VrProcPharRevColumn.PatSex)];
			//entity.PatSex = (Convert.IsDBNull(reader["PAT_SEX"]))?string.Empty:(System.String)reader["PAT_SEX"];
			reader.Close();
	
			entity.AcceptChanges();
		}
		
		/*
		/// <summary>
		/// Refreshes the <see cref="VrProcPharRev"/> object from the <see cref="DataSet"/>.
		/// </summary>
		/// <param name="dataSet">The <see cref="DataSet"/> to read from.</param>
		/// <param name="entity">The <see cref="VrProcPharRev"/> object.</param>
		protected static void RefreshEntity(DataSet dataSet, VrProcPharRev entity)
		{
			DataRow dataRow = dataSet.Tables[0].Rows[0];
			
			entity.DateVisit = (Convert.IsDBNull(dataRow["DATE_VISIT"]))?DateTime.MinValue:(System.DateTime)dataRow["DATE_VISIT"];
			entity.VatNumber = (Convert.IsDBNull(dataRow["VAT_NUmber"]))?string.Empty:(System.String)dataRow["VAT_NUmber"];
			entity.InvNber = (Convert.IsDBNull(dataRow["INV_NBER"]))?string.Empty:(System.String)dataRow["INV_NBER"];
			entity.PatFilcod = (Convert.IsDBNull(dataRow["PAT_FILCOD"]))?string.Empty:(System.String)dataRow["PAT_FILCOD"];
			entity.CashCredit = (Convert.IsDBNull(dataRow["Cash_Credit"]))?string.Empty:(System.String)dataRow["Cash_Credit"];
			entity.ProcPharX = (Convert.IsDBNull(dataRow["PROC_PHAR_X"]))?(short)0:(System.Int16?)dataRow["PROC_PHAR_X"];
			entity.ProcPharCode = (Convert.IsDBNull(dataRow["PROC_PHAR_CODE"]))?string.Empty:(System.String)dataRow["PROC_PHAR_CODE"];
			entity.ProcPharName = (Convert.IsDBNull(dataRow["PROC_PHAR_NAME"]))?string.Empty:(System.String)dataRow["PROC_PHAR_NAME"];
			entity.ProcPharPay = (Convert.IsDBNull(dataRow["PROC_PHAR_PAY"]))?0.0f:(System.Double?)dataRow["PROC_PHAR_PAY"];
			entity.PatNatio = (Convert.IsDBNull(dataRow["PAT_NATIO"]))?string.Empty:(System.String)dataRow["PAT_NATIO"];
			entity.UpdDocCode = (Convert.IsDBNull(dataRow["UPD_DOC_CODE"]))?string.Empty:(System.String)dataRow["UPD_DOC_CODE"];
			entity.UpdDocAlias = (Convert.IsDBNull(dataRow["UPD_DOC_ALIAS"]))?string.Empty:(System.String)dataRow["UPD_DOC_ALIAS"];
			entity.JobCorp = (Convert.IsDBNull(dataRow["JOB_CORP"]))?string.Empty:(System.String)dataRow["JOB_CORP"];
			entity.PatientName = (Convert.IsDBNull(dataRow["Patient_Name"]))?string.Empty:(System.String)dataRow["Patient_Name"];
			entity.AeaProgr = (Convert.IsDBNull(dataRow["AEA_PROGR"]))?string.Empty:(System.String)dataRow["AEA_PROGR"];
			entity.PatDob = (Convert.IsDBNull(dataRow["PAT_DOB"]))?DateTime.MinValue:(System.DateTime?)dataRow["PAT_DOB"];
			entity.DrugName = (Convert.IsDBNull(dataRow["DRUG_NAME"]))?string.Empty:(System.String)dataRow["DRUG_NAME"];
			entity.DispName = (Convert.IsDBNull(dataRow["DISP_NAME"]))?string.Empty:(System.String)dataRow["DISP_NAME"];
			entity.CmsCenter = (Convert.IsDBNull(dataRow["CMS_Center"]))?string.Empty:(System.String)dataRow["CMS_Center"];
			entity.PatSex = (Convert.IsDBNull(dataRow["PAT_SEX"]))?string.Empty:(System.String)dataRow["PAT_SEX"];
			entity.AcceptChanges();
		}
		*/
			
		#endregion Helper Functions
	}//end class

	#region VrProcPharRevFilterBuilder
	
	/// <summary>
	/// A strongly-typed instance of the <see cref="SqlFilterBuilder&lt;EntityColumn&gt;"/> class
	/// that is used exclusively with a <see cref="VrProcPharRev"/> object.
	/// </summary>
	[CLSCompliant(true)]
	public class VrProcPharRevFilterBuilder : SqlFilterBuilder<VrProcPharRevColumn>
	{
		#region Constructors

		/// <summary>
		/// Initializes a new instance of the VrProcPharRevFilterBuilder class.
		/// </summary>
		public VrProcPharRevFilterBuilder() : base() { }

		/// <summary>
		/// Initializes a new instance of the VrProcPharRevFilterBuilder class.
		/// </summary>
		/// <param name="ignoreCase">Specifies whether to create case-insensitive statements.</param>
		public VrProcPharRevFilterBuilder(bool ignoreCase) : base(ignoreCase) { }

		/// <summary>
		/// Initializes a new instance of the VrProcPharRevFilterBuilder class.
		/// </summary>
		/// <param name="ignoreCase">Specifies whether to create case-insensitive statements.</param>
		/// <param name="useAnd">Specifies whether to combine statements using AND or OR.</param>
		public VrProcPharRevFilterBuilder(bool ignoreCase, bool useAnd) : base(ignoreCase, useAnd) { }

		#endregion Constructors
	}

	#endregion VrProcPharRevFilterBuilder

	#region VrProcPharRevParameterBuilder
	
	/// <summary>
	/// A strongly-typed instance of the <see cref="ParameterizedSqlFilterBuilder&lt;EntityColumn&gt;"/> class
	/// that is used exclusively with a <see cref="VrProcPharRev"/> object.
	/// </summary>
	[CLSCompliant(true)]
	public class VrProcPharRevParameterBuilder : ParameterizedSqlFilterBuilder<VrProcPharRevColumn>
	{
		#region Constructors

		/// <summary>
		/// Initializes a new instance of the VrProcPharRevParameterBuilder class.
		/// </summary>
		public VrProcPharRevParameterBuilder() : base() { }

		/// <summary>
		/// Initializes a new instance of the VrProcPharRevParameterBuilder class.
		/// </summary>
		/// <param name="ignoreCase">Specifies whether to create case-insensitive statements.</param>
		public VrProcPharRevParameterBuilder(bool ignoreCase) : base(ignoreCase) { }

		/// <summary>
		/// Initializes a new instance of the VrProcPharRevParameterBuilder class.
		/// </summary>
		/// <param name="ignoreCase">Specifies whether to create case-insensitive statements.</param>
		/// <param name="useAnd">Specifies whether to combine statements using AND or OR.</param>
		public VrProcPharRevParameterBuilder(bool ignoreCase, bool useAnd) : base(ignoreCase, useAnd) { }

		#endregion Constructors
	}

	#endregion VrProcPharRevParameterBuilder
	
	#region VrProcPharRevSortBuilder
    
    /// <summary>
    /// A strongly-typed instance of the <see cref="SqlSortBuilder&lt;EntityColumn&gt;"/> class
	/// that is used exclusively with a <see cref="VrProcPharRev"/> object.
    /// </summary>
    [CLSCompliant(true)]
    public class VrProcPharRevSortBuilder : SqlSortBuilder<VrProcPharRevColumn>
    {
		#region Constructors

		/// <summary>
		/// Initializes a new instance of the VrProcPharRevSqlSortBuilder class.
		/// </summary>
		public VrProcPharRevSortBuilder() : base() { }

		#endregion Constructors

    }    
    #endregion VrProcPharRevSortBuilder

} // end namespace
